Overview
Dataset statistics
| Number of variables | 44 |
|---|---|
| Number of observations | 87980 |
| Missing cells | 88989 |
| Missing cells (%) | 2.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 29.5 MiB |
| Average record size in memory | 352.0 B |
Variable types
| Numeric | 16 |
|---|---|
| Text | 10 |
| Categorical | 14 |
| DateTime | 3 |
| Unsupported | 1 |
release_year has constant value "2006" | Constant |
language_id has constant value "1" | Constant |
district has constant value " " | Constant |
language has constant value "English" | Constant |
actor_id is highly overall correlated with film_actor_id | High correlation |
address_id is highly overall correlated with customer_id and 1 other fields | High correlation |
amount is highly overall correlated with rental_rate | High correlation |
category is highly overall correlated with category_id | High correlation |
category_id is highly overall correlated with category | High correlation |
customer_id is highly overall correlated with address_id and 1 other fields | High correlation |
film_actor_id is highly overall correlated with actor_id | High correlation |
film_category_id is highly overall correlated with film_id and 1 other fields | High correlation |
film_id is highly overall correlated with film_category_id and 1 other fields | High correlation |
inventory_id is highly overall correlated with film_category_id and 1 other fields | High correlation |
manager_staff_id is highly overall correlated with staff_fn and 3 other fields | High correlation |
payment_id is highly overall correlated with address_id and 1 other fields | High correlation |
rental_rate is highly overall correlated with amount | High correlation |
staff_fn is highly overall correlated with manager_staff_id and 3 other fields | High correlation |
staff_id is highly overall correlated with manager_staff_id and 3 other fields | High correlation |
staff_ln is highly overall correlated with manager_staff_id and 3 other fields | High correlation |
store_id is highly overall correlated with manager_staff_id and 3 other fields | High correlation |
active is highly imbalanced (82.7%) | Imbalance |
return_date has 1009 (1.1%) missing values | Missing |
address2 has 87980 (100.0%) missing values | Missing |
address2 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2026-01-14 06:38:37.102482 |
|---|---|
| Analysis finished | 2026-01-14 06:38:52.035068 |
| Duration | 14.93 seconds |
| Software version | ydata-profiling vv4.18.1 |
| Download configuration | config.json |
Variables
film_id
Real number (ℝ)
High correlation
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 502.11853 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 48 |
| Q1 | 255 |
| median | 496 |
| Q3 | 752 |
| 95-th percentile | 952 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 497 |
Descriptive statistics
| Standard deviation | 288.32439 |
|---|---|
| Coefficient of variation (CV) | 0.57421581 |
| Kurtosis | -1.1870348 |
| Mean | 502.11853 |
| Median Absolute Deviation (MAD) | 247 |
| Skewness | -0.010455299 |
| Sum | 44176388 |
| Variance | 83130.956 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 489 | 288 | 0.3% |
| 892 | 276 | 0.3% |
| 880 | 275 | 0.3% |
| 249 | 273 | 0.3% |
| 649 | 264 | 0.3% |
| 301 | 261 | 0.3% |
| 764 | 252 | 0.3% |
| 418 | 248 | 0.3% |
| 369 | 248 | 0.3% |
| 414 | 240 | 0.3% |
| Other values (945) | 85355 |
| Value | Count | Frequency (%) |
| 1 | 230 | |
| 2 | 28 | < 0.1% |
| 3 | 60 | 0.1% |
| 4 | 115 | |
| 5 | 60 | 0.1% |
| 6 | 147 | |
| 7 | 75 | 0.1% |
| 8 | 72 | 0.1% |
| 9 | 108 | |
| 10 | 184 |
| Value | Count | Frequency (%) |
| 1000 | 93 | |
| 999 | 85 | |
| 998 | 54 | 0.1% |
| 997 | 30 | < 0.1% |
| 996 | 35 | < 0.1% |
| 995 | 23 | < 0.1% |
| 994 | 78 | |
| 993 | 180 | |
| 992 | 56 | 0.1% |
| 991 | 64 | 0.1% |
title
Text
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 27 |
|---|---|
| Median length | 22 |
| Mean length | 14.313969 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BLANKET BEVERLY |
|---|---|
| 2nd row | BLANKET BEVERLY |
| 3rd row | BLANKET BEVERLY |
| 4th row | BLANKET BEVERLY |
| 5th row | FREAKY POCUS |
| Value | Count | Frequency (%) |
| heartbreakers | 659 | 0.4% |
| boondock | 655 | 0.4% |
| armageddon | 647 | 0.4% |
| hellfighters | 642 | 0.4% |
| apollo | 625 | 0.4% |
| polish | 597 | 0.3% |
| shakespeare | 576 | 0.3% |
| desire | 568 | 0.3% |
| instinct | 558 | 0.3% |
| love | 548 | 0.3% |
| Other values (974) | 169885 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 124731 | 9.9% |
| A | 106201 | 8.4% |
| R | 91933 | 7.3% |
| O | 88834 | 7.1% |
| 87980 | 7.0% | |
| N | 83346 | 6.6% |
| I | 83028 | 6.6% |
| S | 78689 | 6.2% |
| T | 72852 | 5.8% |
| L | 60358 | 4.8% |
| Other values (17) | 381391 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1171363 | |
| Space Separator | 87980 | 7.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 124731 | 10.6% |
| A | 106201 | 9.1% |
| R | 91933 | 7.8% |
| O | 88834 | 7.6% |
| N | 83346 | 7.1% |
| I | 83028 | 7.1% |
| S | 78689 | 6.7% |
| T | 72852 | 6.2% |
| L | 60358 | 5.2% |
| C | 47904 | 4.1% |
| Other values (16) | 333487 |
Space Separator
| Value | Count | Frequency (%) |
| 87980 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1171363 | |
| Common | 87980 | 7.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 124731 | 10.6% |
| A | 106201 | 9.1% |
| R | 91933 | 7.8% |
| O | 88834 | 7.6% |
| N | 83346 | 7.1% |
| I | 83028 | 7.1% |
| S | 78689 | 6.7% |
| T | 72852 | 6.2% |
| L | 60358 | 5.2% |
| C | 47904 | 4.1% |
| Other values (16) | 333487 |
Common
| Value | Count | Frequency (%) |
| 87980 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1259343 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 124731 | 9.9% |
| A | 106201 | 8.4% |
| R | 91933 | 7.3% |
| O | 88834 | 7.1% |
| 87980 | 7.0% | |
| N | 83346 | 6.6% |
| I | 83028 | 6.6% |
| S | 78689 | 6.2% |
| T | 72852 | 5.8% |
| L | 60358 | 4.8% |
| Other values (17) | 381391 |
description
Text
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 130 |
|---|---|
| Median length | 115 |
| Mean length | 94.309241 |
| Min length | 70 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria |
|---|---|
| 2nd row | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria |
| 3rd row | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria |
| 4th row | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria |
| 5th row | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico |
| Value | Count | Frequency (%) |
| a | 388545 | |
| of | 91030 | 5.6% |
| and | 87980 | 5.4% |
| who | 87980 | 5.4% |
| must | 87980 | 5.4% |
| in | 87980 | 5.4% |
| the | 16917 | 1.0% |
| mad | 15834 | 1.0% |
| shark | 10679 | 0.7% |
| boat | 10371 | 0.6% |
| Other values (139) | 731635 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1528951 | ||
| a | 727326 | 8.8% |
| n | 571906 | 6.9% |
| o | 508316 | 6.1% |
| e | 496071 | 6.0% |
| t | 473278 | 5.7% |
| i | 420949 | 5.1% |
| r | 339771 | 4.1% |
| s | 298832 | 3.6% |
| A | 286028 | 3.4% |
| Other values (42) | 2645899 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5722202 | |
| Space Separator | 1528951 | 18.4% |
| Uppercase Letter | 1029104 | 12.4% |
| Dash Punctuation | 17070 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 727326 | |
| n | 571906 | |
| o | 508316 | 8.9% |
| e | 496071 | 8.7% |
| t | 473278 | 8.3% |
| i | 420949 | 7.4% |
| r | 339771 | 5.9% |
| s | 298832 | 5.2% |
| u | 272387 | 4.8% |
| h | 208522 | 3.6% |
| Other values (16) | 1404844 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 286028 | |
| S | 102821 | 10.0% |
| C | 85129 | 8.3% |
| M | 69641 | 6.8% |
| D | 61483 | 6.0% |
| B | 59350 | 5.8% |
| T | 57431 | 5.6% |
| F | 56860 | 5.5% |
| P | 46769 | 4.5% |
| W | 32959 | 3.2% |
| Other values (14) | 170633 |
Space Separator
| Value | Count | Frequency (%) |
| 1528951 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 17070 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6751306 | |
| Common | 1546021 | 18.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 727326 | 10.8% |
| n | 571906 | 8.5% |
| o | 508316 | 7.5% |
| e | 496071 | 7.3% |
| t | 473278 | 7.0% |
| i | 420949 | 6.2% |
| r | 339771 | 5.0% |
| s | 298832 | 4.4% |
| A | 286028 | 4.2% |
| u | 272387 | 4.0% |
| Other values (40) | 2356442 |
Common
| Value | Count | Frequency (%) |
| 1528951 | ||
| - | 17070 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8297327 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1528951 | ||
| a | 727326 | 8.8% |
| n | 571906 | 6.9% |
| o | 508316 | 6.1% |
| e | 496071 | 6.0% |
| t | 473278 | 5.7% |
| i | 420949 | 5.1% |
| r | 339771 | 4.1% |
| s | 298832 | 3.6% |
| A | 286028 | 3.4% |
| Other values (42) | 2645899 |
release_year
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| 2006 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2006 |
|---|---|
| 2nd row | 2006 |
| 3rd row | 2006 |
| 4th row | 2006 |
| 5th row | 2006 |
Common Values
| Value | Count | Frequency (%) |
| 2006 | 87980 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2006 | 87980 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 175960 | |
| 2 | 87980 | |
| 6 | 87980 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 351920 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 175960 | |
| 2 | 87980 | |
| 6 | 87980 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 351920 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 175960 | |
| 2 | 87980 | |
| 6 | 87980 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 351920 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 175960 | |
| 2 | 87980 | |
| 6 | 87980 |
language_id
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 87980 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 87980 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 87980 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 87980 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 87980 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 87980 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 87980 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87980 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 87980 |
rental_duration
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| 6 | |
|---|---|
| 4 | |
| 3 | |
| 5 | |
| 7 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 7 |
|---|---|
| 2nd row | 7 |
| 3rd row | 7 |
| 4th row | 7 |
| 5th row | 7 |
Common Values
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18208 | |
| 5 | 17551 | |
| 7 | 14299 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18208 | |
| 5 | 17551 | |
| 7 | 14299 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18208 | |
| 5 | 17551 | |
| 7 | 14299 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 87980 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18208 | |
| 5 | 17551 | |
| 7 | 14299 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 87980 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18208 | |
| 5 | 17551 | |
| 7 | 14299 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87980 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18208 | |
| 5 | 17551 | |
| 7 | 14299 |
rental_rate
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| 0.99 | |
|---|---|
| 2.99 | |
| 4.99 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.99 |
|---|---|
| 2nd row | 2.99 |
| 3rd row | 2.99 |
| 4th row | 2.99 |
| 5th row | 2.99 |
Common Values
| Value | Count | Frequency (%) |
| 0.99 | 31130 | |
| 2.99 | 28943 | |
| 4.99 | 27907 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.99 | 31130 | |
| 2.99 | 28943 | |
| 4.99 | 27907 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 175960 | |
| . | 87980 | |
| 0 | 31130 | 8.8% |
| 2 | 28943 | 8.2% |
| 4 | 27907 | 7.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 263940 | |
| Other Punctuation | 87980 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 175960 | |
| 0 | 31130 | 11.8% |
| 2 | 28943 | 11.0% |
| 4 | 27907 | 10.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 87980 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 351920 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 175960 | |
| . | 87980 | |
| 0 | 31130 | 8.8% |
| 2 | 28943 | 8.2% |
| 4 | 27907 | 7.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 351920 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 175960 | |
| . | 87980 | |
| 0 | 31130 | 8.8% |
| 2 | 28943 | 8.2% |
| 4 | 27907 | 7.9% |
length
Real number (ℝ)
| Distinct | 140 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 115.10414 |
| Minimum | 46 |
|---|---|
| Maximum | 185 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 46 |
|---|---|
| 5-th percentile | 52 |
| Q1 | 80 |
| median | 114 |
| Q3 | 150 |
| 95-th percentile | 178 |
| Maximum | 185 |
| Range | 139 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 40.499913 |
|---|---|
| Coefficient of variation (CV) | 0.35185454 |
| Kurtosis | -1.197223 |
| Mean | 115.10414 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 0.02742301 |
| Sum | 10126862 |
| Variance | 1640.2429 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85 | 1495 | 1.7% |
| 112 | 1358 | 1.5% |
| 178 | 1355 | 1.5% |
| 84 | 1178 | 1.3% |
| 80 | 1072 | 1.2% |
| 63 | 1070 | 1.2% |
| 75 | 1056 | 1.2% |
| 92 | 1041 | 1.2% |
| 179 | 1019 | 1.2% |
| 161 | 1008 | 1.1% |
| Other values (130) | 76328 |
| Value | Count | Frequency (%) |
| 46 | 585 | |
| 47 | 732 | |
| 48 | 832 | |
| 49 | 369 | |
| 50 | 563 | |
| 51 | 647 | |
| 52 | 704 | |
| 53 | 759 | |
| 54 | 524 | |
| 55 | 336 |
| Value | Count | Frequency (%) |
| 185 | 936 | |
| 184 | 393 | 0.4% |
| 183 | 417 | 0.5% |
| 182 | 252 | 0.3% |
| 181 | 837 | |
| 180 | 376 | 0.4% |
| 179 | 1019 | |
| 178 | 1355 | |
| 177 | 660 | |
| 176 | 893 |
replacement_cost
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.190762 |
| Minimum | 9.99 |
|---|---|
| Maximum | 29.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 9.99 |
|---|---|
| 5-th percentile | 10.99 |
| Q1 | 14.99 |
| median | 20.99 |
| Q3 | 24.99 |
| 95-th percentile | 29.99 |
| Maximum | 29.99 |
| Range | 20 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.0882873 |
|---|---|
| Coefficient of variation (CV) | 0.30153827 |
| Kurtosis | -1.2239788 |
| Mean | 20.190762 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.0352181 |
| Sum | 1776383.2 |
| Variance | 37.067243 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22.99 | 5626 | 6.4% |
| 27.99 | 5215 | 5.9% |
| 12.99 | 5024 | 5.7% |
| 14.99 | 4893 | 5.6% |
| 21.99 | 4886 | 5.6% |
| 29.99 | 4686 | 5.3% |
| 20.99 | 4672 | 5.3% |
| 26.99 | 4264 | 4.8% |
| 13.99 | 4213 | 4.8% |
| 11.99 | 4167 | 4.7% |
| Other values (11) | 40334 |
| Value | Count | Frequency (%) |
| 9.99 | 3924 | |
| 10.99 | 3526 | |
| 11.99 | 4167 | |
| 12.99 | 5024 | |
| 13.99 | 4213 | |
| 14.99 | 4893 | |
| 15.99 | 3141 | |
| 16.99 | 3593 | |
| 17.99 | 3748 | |
| 18.99 | 3744 |
| Value | Count | Frequency (%) |
| 29.99 | 4686 | |
| 28.99 | 4080 | |
| 27.99 | 5215 | |
| 26.99 | 4264 | |
| 25.99 | 3727 | |
| 24.99 | 3431 | |
| 23.99 | 3870 | |
| 22.99 | 5626 | |
| 21.99 | 4886 | |
| 20.99 | 4672 |
rating
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| PG-13 | |
|---|---|
| PG | |
| NC-17 | |
| R | |
| G |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.8801432 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | G |
|---|---|
| 2nd row | G |
| 3rd row | G |
| 4th row | G |
| 5th row | R |
Common Values
| Value | Count | Frequency (%) |
| PG-13 | 19065 | |
| PG | 18635 | |
| NC-17 | 17630 | |
| R | 17210 | |
| G | 15440 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pg-13 | 19065 | |
| pg | 18635 | |
| nc-17 | 17630 | |
| r | 17210 | |
| g | 15440 |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 53140 | |
| P | 37700 | |
| - | 36695 | |
| 1 | 36695 | |
| 3 | 19065 | 7.5% |
| N | 17630 | 7.0% |
| C | 17630 | 7.0% |
| 7 | 17630 | 7.0% |
| R | 17210 | 6.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 143310 | |
| Decimal Number | 73390 | |
| Dash Punctuation | 36695 | 14.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 53140 | |
| P | 37700 | |
| N | 17630 | 12.3% |
| C | 17630 | 12.3% |
| R | 17210 | 12.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 36695 | |
| 3 | 19065 | |
| 7 | 17630 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 36695 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 143310 | |
| Common | 110085 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 53140 | |
| P | 37700 | |
| N | 17630 | 12.3% |
| C | 17630 | 12.3% |
| R | 17210 | 12.0% |
Common
| Value | Count | Frequency (%) |
| - | 36695 | |
| 1 | 36695 | |
| 3 | 19065 | |
| 7 | 17630 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 253395 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| G | 53140 | |
| P | 37700 | |
| - | 36695 | |
| 1 | 36695 | |
| 3 | 19065 | 7.5% |
| N | 17630 | 7.0% |
| C | 17630 | 7.0% |
| 7 | 17630 | 7.0% |
| R | 17210 | 6.8% |
actor_id
Real number (ℝ)
High correlation
| Distinct | 200 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.9536 |
| Minimum | 1 |
|---|---|
| Maximum | 200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 52 |
| median | 102 |
| Q3 | 149 |
| 95-th percentile | 191 |
| Maximum | 200 |
| Range | 199 |
| Interquartile range (IQR) | 97 |
Descriptive statistics
| Standard deviation | 56.900302 |
|---|---|
| Coefficient of variation (CV) | 0.56362824 |
| Kurtosis | -1.1747542 |
| Mean | 100.9536 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | 0.0020452118 |
| Sum | 8881898 |
| Variance | 3237.6443 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 107 | 753 | 0.9% |
| 181 | 678 | 0.8% |
| 198 | 674 | 0.8% |
| 144 | 654 | 0.7% |
| 102 | 640 | 0.7% |
| 60 | 612 | 0.7% |
| 150 | 611 | 0.7% |
| 37 | 605 | 0.7% |
| 23 | 604 | 0.7% |
| 90 | 599 | 0.7% |
| Other values (190) | 81550 |
| Value | Count | Frequency (%) |
| 1 | 305 | |
| 2 | 387 | |
| 3 | 311 | |
| 4 | 274 | |
| 5 | 496 | |
| 6 | 279 | |
| 7 | 479 | |
| 8 | 317 | |
| 9 | 381 | |
| 10 | 362 |
| Value | Count | Frequency (%) |
| 200 | 346 | |
| 199 | 255 | 0.3% |
| 198 | 674 | |
| 197 | 553 | |
| 196 | 450 | |
| 195 | 450 | |
| 194 | 380 | |
| 193 | 444 | |
| 192 | 458 | |
| 191 | 523 |
actor_fn
Text
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 5.3013185 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FRED |
|---|---|
| 2nd row | ALAN |
| 3rd row | BURT |
| 4th row | THORA |
| 5th row | TOM |
| Value | Count | Frequency (%) |
| penelope | 1661 | 1.9% |
| kenneth | 1643 | 1.9% |
| jayne | 1565 | 1.8% |
| matthew | 1518 | 1.7% |
| julia | 1435 | 1.6% |
| groucho | 1350 | 1.5% |
| morgan | 1340 | 1.5% |
| ed | 1310 | 1.5% |
| burt | 1304 | 1.5% |
| christian | 1286 | 1.5% |
| Other values (118) | 73568 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 65221 | |
| A | 52730 | 11.3% |
| R | 41082 | 8.8% |
| N | 40749 | 8.7% |
| L | 29589 | 6.3% |
| I | 29424 | 6.3% |
| O | 18594 | 4.0% |
| S | 18574 | 4.0% |
| T | 18148 | 3.9% |
| M | 17206 | 3.7% |
| Other values (14) | 135093 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 466410 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 65221 | |
| A | 52730 | 11.3% |
| R | 41082 | 8.8% |
| N | 40749 | 8.7% |
| L | 29589 | 6.3% |
| I | 29424 | 6.3% |
| O | 18594 | 4.0% |
| S | 18574 | 4.0% |
| T | 18148 | 3.9% |
| M | 17206 | 3.7% |
| Other values (14) | 135093 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 466410 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 65221 | |
| A | 52730 | 11.3% |
| R | 41082 | 8.8% |
| N | 40749 | 8.7% |
| L | 29589 | 6.3% |
| I | 29424 | 6.3% |
| O | 18594 | 4.0% |
| S | 18574 | 4.0% |
| T | 18148 | 3.9% |
| M | 17206 | 3.7% |
| Other values (14) | 135093 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 466410 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 65221 | |
| A | 52730 | 11.3% |
| R | 41082 | 8.8% |
| N | 40749 | 8.7% |
| L | 29589 | 6.3% |
| I | 29424 | 6.3% |
| O | 18594 | 4.0% |
| S | 18574 | 4.0% |
| T | 18148 | 3.9% |
| M | 17206 | 3.7% |
| Other values (14) | 135093 |
actor_ln
Text
| Distinct | 121 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 9 |
| Mean length | 6.2452489 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COSTNER |
|---|---|
| 2nd row | DREYFUSS |
| 3rd row | TEMPLE |
| 4th row | TEMPLE |
| 5th row | MIRANDA |
| Value | Count | Frequency (%) |
| kilmer | 2145 | 2.4% |
| nolte | 2119 | 2.4% |
| temple | 1778 | 2.0% |
| degeneres | 1611 | 1.8% |
| keitel | 1586 | 1.8% |
| berry | 1480 | 1.7% |
| torn | 1478 | 1.7% |
| hoffman | 1455 | 1.7% |
| guiness | 1425 | 1.6% |
| garland | 1394 | 1.6% |
| Other values (111) | 71509 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 68603 | |
| N | 44874 | 8.2% |
| R | 41113 | 7.5% |
| A | 39729 | 7.2% |
| O | 39689 | 7.2% |
| L | 39441 | 7.2% |
| I | 33954 | 6.2% |
| S | 32294 | 5.9% |
| T | 23663 | 4.3% |
| D | 21500 | 3.9% |
| Other values (17) | 164597 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 548971 | |
| Dash Punctuation | 486 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 68603 | |
| N | 44874 | 8.2% |
| R | 41113 | 7.5% |
| A | 39729 | 7.2% |
| O | 39689 | 7.2% |
| L | 39441 | 7.2% |
| I | 33954 | 6.2% |
| S | 32294 | 5.9% |
| T | 23663 | 4.3% |
| D | 21500 | 3.9% |
| Other values (16) | 164111 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 486 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 548971 | |
| Common | 486 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 68603 | |
| N | 44874 | 8.2% |
| R | 41113 | 7.5% |
| A | 39729 | 7.2% |
| O | 39689 | 7.2% |
| L | 39441 | 7.2% |
| I | 33954 | 6.2% |
| S | 32294 | 5.9% |
| T | 23663 | 4.3% |
| D | 21500 | 3.9% |
| Other values (16) | 164111 |
Common
| Value | Count | Frequency (%) |
| - | 486 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 549457 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 68603 | |
| N | 44874 | 8.2% |
| R | 41113 | 7.5% |
| A | 39729 | 7.2% |
| O | 39689 | 7.2% |
| L | 39441 | 7.2% |
| I | 33954 | 6.2% |
| S | 32294 | 5.9% |
| T | 23663 | 4.3% |
| D | 21500 | 3.9% |
| Other values (17) | 164597 |
customer_id
Real number (ℝ)
High correlation
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 297.18662 |
| Minimum | 1 |
|---|---|
| Maximum | 599 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 148 |
| median | 296 |
| Q3 | 446 |
| 95-th percentile | 568 |
| Maximum | 599 |
| Range | 598 |
| Interquartile range (IQR) | 298 |
Descriptive statistics
| Standard deviation | 172.25283 |
|---|---|
| Coefficient of variation (CV) | 0.57961164 |
| Kurtosis | -1.1882855 |
| Mean | 297.18662 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | 0.0085538465 |
| Sum | 26146479 |
| Variance | 29671.036 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 148 | 272 | 0.3% |
| 526 | 251 | 0.3% |
| 197 | 244 | 0.3% |
| 144 | 239 | 0.3% |
| 236 | 233 | 0.3% |
| 75 | 233 | 0.3% |
| 29 | 223 | 0.3% |
| 257 | 221 | 0.3% |
| 178 | 220 | 0.3% |
| 410 | 216 | 0.2% |
| Other values (589) | 85628 |
| Value | Count | Frequency (%) |
| 1 | 156 | |
| 2 | 175 | |
| 3 | 144 | |
| 4 | 121 | |
| 5 | 183 | |
| 6 | 171 | |
| 7 | 191 | |
| 8 | 152 | |
| 9 | 129 | |
| 10 | 123 |
| Value | Count | Frequency (%) |
| 599 | 102 | |
| 598 | 102 | |
| 597 | 144 | |
| 596 | 158 | |
| 595 | 141 | |
| 594 | 141 | |
| 593 | 129 | |
| 592 | 145 | |
| 591 | 120 | |
| 590 | 134 |
cust_fn
Text
| Distinct | 591 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 5.6729484 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CHARLOTTE |
|---|---|
| 2nd row | CHARLOTTE |
| 3rd row | CHARLOTTE |
| 4th row | CHARLOTTE |
| 5th row | TOMMY |
| Value | Count | Frequency (%) |
| marion | 388 | 0.4% |
| leslie | 325 | 0.4% |
| tracy | 303 | 0.3% |
| terry | 291 | 0.3% |
| willie | 291 | 0.3% |
| jessie | 290 | 0.3% |
| jamie | 277 | 0.3% |
| eleanor | 272 | 0.3% |
| kelly | 272 | 0.3% |
| karl | 251 | 0.3% |
| Other values (581) | 85020 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 62884 | |
| A | 61284 | |
| R | 47045 | 9.4% |
| N | 42774 | 8.6% |
| I | 38750 | 7.8% |
| L | 36712 | 7.4% |
| O | 23409 | 4.7% |
| T | 21484 | 4.3% |
| S | 19614 | 3.9% |
| D | 18887 | 3.8% |
| Other values (16) | 126263 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 499106 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 62884 | |
| A | 61284 | |
| R | 47045 | 9.4% |
| N | 42774 | 8.6% |
| I | 38750 | 7.8% |
| L | 36712 | 7.4% |
| O | 23409 | 4.7% |
| T | 21484 | 4.3% |
| S | 19614 | 3.9% |
| D | 18887 | 3.8% |
| Other values (16) | 126263 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 499106 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 62884 | |
| A | 61284 | |
| R | 47045 | 9.4% |
| N | 42774 | 8.6% |
| I | 38750 | 7.8% |
| L | 36712 | 7.4% |
| O | 23409 | 4.7% |
| T | 21484 | 4.3% |
| S | 19614 | 3.9% |
| D | 18887 | 3.8% |
| Other values (16) | 126263 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 499106 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 62884 | |
| A | 61284 | |
| R | 47045 | 9.4% |
| N | 42774 | 8.6% |
| I | 38750 | 7.8% |
| L | 36712 | 7.4% |
| O | 23409 | 4.7% |
| T | 21484 | 4.3% |
| S | 19614 | 3.9% |
| D | 18887 | 3.8% |
| Other values (16) | 126263 |
cust_ln
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 6.1921459 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HUNTER |
|---|---|
| 2nd row | HUNTER |
| 3rd row | HUNTER |
| 4th row | HUNTER |
| 5th row | COLLAZO |
| Value | Count | Frequency (%) |
| hunt | 272 | 0.3% |
| seal | 251 | 0.3% |
| peters | 244 | 0.3% |
| shaw | 239 | 0.3% |
| dean | 233 | 0.3% |
| sanders | 233 | 0.3% |
| hernandez | 223 | 0.3% |
| douglas | 221 | 0.3% |
| snyder | 220 | 0.3% |
| irby | 216 | 0.2% |
| Other values (589) | 85628 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 58265 | 10.7% |
| R | 54380 | 10.0% |
| A | 47359 | 8.7% |
| N | 43534 | 8.0% |
| O | 38957 | 7.2% |
| L | 38567 | 7.1% |
| S | 35961 | 6.6% |
| I | 26872 | 4.9% |
| T | 26008 | 4.8% |
| H | 20076 | 3.7% |
| Other values (16) | 154806 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 544785 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 58265 | 10.7% |
| R | 54380 | 10.0% |
| A | 47359 | 8.7% |
| N | 43534 | 8.0% |
| O | 38957 | 7.2% |
| L | 38567 | 7.1% |
| S | 35961 | 6.6% |
| I | 26872 | 4.9% |
| T | 26008 | 4.8% |
| H | 20076 | 3.7% |
| Other values (16) | 154806 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 544785 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 58265 | 10.7% |
| R | 54380 | 10.0% |
| A | 47359 | 8.7% |
| N | 43534 | 8.0% |
| O | 38957 | 7.2% |
| L | 38567 | 7.1% |
| S | 35961 | 6.6% |
| I | 26872 | 4.9% |
| T | 26008 | 4.8% |
| H | 20076 | 3.7% |
| Other values (16) | 154806 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 544785 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 58265 | 10.7% |
| R | 54380 | 10.0% |
| A | 47359 | 8.7% |
| N | 43534 | 8.0% |
| O | 38957 | 7.2% |
| L | 38567 | 7.1% |
| S | 35961 | 6.6% |
| I | 26872 | 4.9% |
| T | 26008 | 4.8% |
| H | 20076 | 3.7% |
| Other values (16) | 154806 |
email
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 40 |
|---|---|
| Median length | 38 |
| Mean length | 31.865094 |
| Min length | 26 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CHARLOTTE.HUNTER@sakilacustomer.org |
|---|---|
| 2nd row | CHARLOTTE.HUNTER@sakilacustomer.org |
| 3rd row | CHARLOTTE.HUNTER@sakilacustomer.org |
| 4th row | CHARLOTTE.HUNTER@sakilacustomer.org |
| 5th row | TOMMY.COLLAZO@sakilacustomer.org |
| Value | Count | Frequency (%) |
| eleanor.hunt@sakilacustomer.org | 272 | 0.3% |
| karl.seal@sakilacustomer.org | 251 | 0.3% |
| sue.peters@sakilacustomer.org | 244 | 0.3% |
| clara.shaw@sakilacustomer.org | 239 | 0.3% |
| marcia.dean@sakilacustomer.org | 233 | 0.3% |
| tammy.sanders@sakilacustomer.org | 233 | 0.3% |
| angela.hernandez@sakilacustomer.org | 223 | 0.3% |
| marsha.douglas@sakilacustomer.org | 221 | 0.3% |
| marion.snyder@sakilacustomer.org | 220 | 0.3% |
| curtis.irby@sakilacustomer.org | 216 | 0.2% |
| Other values (589) | 85628 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 175960 | 6.3% |
| . | 175960 | 6.3% |
| o | 175960 | 6.3% |
| s | 175960 | 6.3% |
| a | 175960 | 6.3% |
| E | 121149 | 4.3% |
| A | 108643 | 3.9% |
| R | 101425 | 3.6% |
| l | 87980 | 3.1% |
| g | 87980 | 3.1% |
| Other values (31) | 1416514 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1495660 | |
| Uppercase Letter | 1043891 | |
| Other Punctuation | 263940 | 9.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 121149 | |
| A | 108643 | 10.4% |
| R | 101425 | 9.7% |
| N | 86308 | 8.3% |
| L | 75279 | 7.2% |
| I | 65622 | 6.3% |
| O | 62366 | 6.0% |
| S | 55575 | 5.3% |
| T | 47492 | 4.5% |
| C | 36337 | 3.5% |
| Other values (16) | 283695 |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 175960 | |
| o | 175960 | |
| s | 175960 | |
| a | 175960 | |
| l | 87980 | 5.9% |
| g | 87980 | 5.9% |
| e | 87980 | 5.9% |
| t | 87980 | 5.9% |
| u | 87980 | 5.9% |
| c | 87980 | 5.9% |
| Other values (3) | 263940 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 175960 | |
| @ | 87980 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2539551 | |
| Common | 263940 | 9.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 175960 | 6.9% |
| o | 175960 | 6.9% |
| s | 175960 | 6.9% |
| a | 175960 | 6.9% |
| E | 121149 | 4.8% |
| A | 108643 | 4.3% |
| R | 101425 | 4.0% |
| l | 87980 | 3.5% |
| g | 87980 | 3.5% |
| e | 87980 | 3.5% |
| Other values (29) | 1240554 |
Common
| Value | Count | Frequency (%) |
| . | 175960 | |
| @ | 87980 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2803491 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 175960 | 6.3% |
| . | 175960 | 6.3% |
| o | 175960 | 6.3% |
| s | 175960 | 6.3% |
| a | 175960 | 6.3% |
| E | 121149 | 4.3% |
| A | 108643 | 3.9% |
| R | 101425 | 3.6% |
| l | 87980 | 3.1% |
| g | 87980 | 3.1% |
| Other values (31) | 1416514 |
active
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| 1 | |
|---|---|
| 0 | 2266 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 85714 | |
| 0 | 2266 | 2.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 85714 | |
| 0 | 2266 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 85714 | |
| 0 | 2266 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 87980 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 85714 | |
| 0 | 2266 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 87980 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 85714 | |
| 0 | 2266 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87980 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 85714 | |
| 0 | 2266 | 2.6% |
rental_id
Real number (ℝ)
| Distinct | 16004 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8034.5767 |
| Minimum | 1 |
|---|---|
| Maximum | 16049 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 820 |
| Q1 | 4030.75 |
| median | 8041.5 |
| Q3 | 12027.25 |
| 95-th percentile | 15247.05 |
| Maximum | 16049 |
| Range | 16048 |
| Interquartile range (IQR) | 7996.5 |
Descriptive statistics
| Standard deviation | 4630.5566 |
|---|---|
| Coefficient of variation (CV) | 0.57632863 |
| Kurtosis | -1.2005905 |
| Mean | 8034.5767 |
| Median Absolute Deviation (MAD) | 4000.5 |
| Skewness | -0.0012045241 |
| Sum | 7.0688206 × 108 |
| Variance | 21442055 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 4845 | 15 | < 0.1% |
| 5221 | 15 | < 0.1% |
| 7446 | 15 | < 0.1% |
| 14200 | 15 | < 0.1% |
| 7152 | 15 | < 0.1% |
| 12701 | 15 | < 0.1% |
| 15187 | 15 | < 0.1% |
| 2796 | 15 | < 0.1% |
| 5930 | 15 | < 0.1% |
| 8014 | 15 | < 0.1% |
| Other values (15994) | 87830 |
| Value | Count | Frequency (%) |
| 1 | 4 | |
| 2 | 5 | |
| 3 | 2 | < 0.1% |
| 4 | 4 | |
| 5 | 8 | |
| 6 | 4 | |
| 7 | 6 | |
| 8 | 4 | |
| 9 | 3 | < 0.1% |
| 10 | 7 |
| Value | Count | Frequency (%) |
| 16049 | 6 | |
| 16048 | 2 | < 0.1% |
| 16047 | 7 | |
| 16046 | 5 | |
| 16045 | 5 | |
| 16044 | 5 | |
| 16043 | 7 | |
| 16042 | 3 | < 0.1% |
| 16041 | 6 | |
| 16040 | 8 |
rental_date
Date
| Distinct | 15776 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| Minimum | 2005-05-24 22:53:30 |
|---|---|
| Maximum | 2006-02-14 15:16:03 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
return_date
Date
Missing
| Distinct | 15796 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 1009 |
| Missing (%) | 1.1% |
| Memory size | 687.5 KiB |
| Minimum | 2005-05-25 23:55:21 |
|---|---|
| Maximum | 2005-09-02 02:35:22 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
payment_id
Real number (ℝ)
High correlation
| Distinct | 16004 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8025.7845 |
| Minimum | 1 |
|---|---|
| Maximum | 16049 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 796 |
| Q1 | 4037 |
| median | 8032 |
| Q3 | 12028 |
| 95-th percentile | 15217 |
| Maximum | 16049 |
| Range | 16048 |
| Interquartile range (IQR) | 7991 |
Descriptive statistics
| Standard deviation | 4627.488 |
|---|---|
| Coefficient of variation (CV) | 0.57657765 |
| Kurtosis | -1.1977116 |
| Mean | 8025.7845 |
| Median Absolute Deviation (MAD) | 3995 |
| Skewness | -0.0063754037 |
| Sum | 7.0610852 × 108 |
| Variance | 21413645 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14839 | 15 | < 0.1% |
| 2280 | 15 | < 0.1% |
| 13129 | 15 | < 0.1% |
| 9457 | 15 | < 0.1% |
| 10004 | 15 | < 0.1% |
| 13202 | 15 | < 0.1% |
| 12463 | 15 | < 0.1% |
| 5662 | 15 | < 0.1% |
| 6853 | 15 | < 0.1% |
| 288 | 15 | < 0.1% |
| Other values (15994) | 87830 |
| Value | Count | Frequency (%) |
| 1 | 4 | |
| 2 | 5 | |
| 3 | 1 | < 0.1% |
| 4 | 3 | |
| 5 | 1 | < 0.1% |
| 6 | 6 | |
| 7 | 4 | |
| 8 | 6 | |
| 9 | 5 | |
| 10 | 5 |
| Value | Count | Frequency (%) |
| 16049 | 4 | |
| 16048 | 8 | |
| 16047 | 5 | |
| 16046 | 4 | |
| 16045 | 3 | < 0.1% |
| 16044 | 5 | |
| 16043 | 3 | < 0.1% |
| 16042 | 5 | |
| 16041 | 9 | |
| 16040 | 6 |
amount
Real number (ℝ)
High correlation
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1777571 |
| Minimum | 0 |
|---|---|
| Maximum | 11.99 |
| Zeros | 133 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.99 |
| Q1 | 2.99 |
| median | 3.99 |
| Q3 | 4.99 |
| 95-th percentile | 8.99 |
| Maximum | 11.99 |
| Range | 11.99 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.3455906 |
|---|---|
| Coefficient of variation (CV) | 0.56144734 |
| Kurtosis | -0.24036645 |
| Mean | 4.1777571 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.46814077 |
| Sum | 367559.07 |
| Variance | 5.5017954 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.99 | 20434 | |
| 2.99 | 19873 | |
| 0.99 | 16264 | |
| 5.99 | 7181 | 8.2% |
| 3.99 | 6350 | 7.2% |
| 6.99 | 5929 | 6.7% |
| 7.99 | 3654 | 4.2% |
| 1.99 | 3490 | 4.0% |
| 8.99 | 2633 | 3.0% |
| 9.99 | 1302 | 1.5% |
| Other values (9) | 870 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 133 | 0.2% |
| 0.99 | 16264 | |
| 1.98 | 4 | < 0.1% |
| 1.99 | 3490 | 4.0% |
| 2.99 | 19873 | |
| 3.98 | 43 | < 0.1% |
| 3.99 | 6350 | 7.2% |
| 4.99 | 20434 | |
| 5.98 | 47 | 0.1% |
| 5.99 | 7181 | 8.2% |
| Value | Count | Frequency (%) |
| 11.99 | 49 | 0.1% |
| 10.99 | 549 | 0.6% |
| 9.99 | 1302 | 1.5% |
| 9.98 | 6 | < 0.1% |
| 8.99 | 2633 | 3.0% |
| 8.97 | 7 | < 0.1% |
| 7.99 | 3654 | |
| 7.98 | 32 | < 0.1% |
| 6.99 | 5929 | |
| 5.99 | 7181 |
payment_date
Date
| Distinct | 15776 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| Minimum | 2005-05-24 22:53:30 |
|---|---|
| Maximum | 2006-02-14 15:16:03 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
inventory_id
Real number (ℝ)
High correlation
| Distinct | 4567 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2296.5277 |
| Minimum | 1 |
|---|---|
| Maximum | 4581 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 213.95 |
| Q1 | 1158 |
| median | 2287 |
| Q3 | 3428 |
| 95-th percentile | 4367 |
| Maximum | 4581 |
| Range | 4580 |
| Interquartile range (IQR) | 2270 |
Descriptive statistics
| Standard deviation | 1321.2774 |
|---|---|
| Coefficient of variation (CV) | 0.575337 |
| Kurtosis | -1.1818466 |
| Mean | 2296.5277 |
| Median Absolute Deviation (MAD) | 1134 |
| Skewness | -0.0063442828 |
| Sum | 2.0204851 × 108 |
| Variance | 1745773.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1122 | 65 | 0.1% |
| 1123 | 65 | 0.1% |
| 158 | 60 | 0.1% |
| 2337 | 60 | 0.1% |
| 4095 | 60 | 0.1% |
| 2424 | 60 | 0.1% |
| 2371 | 60 | 0.1% |
| 1899 | 60 | 0.1% |
| 2423 | 60 | 0.1% |
| 2962 | 55 | 0.1% |
| Other values (4557) | 87375 |
| Value | Count | Frequency (%) |
| 1 | 30 | |
| 2 | 50 | |
| 3 | 20 | < 0.1% |
| 4 | 20 | < 0.1% |
| 6 | 50 | |
| 7 | 40 | |
| 8 | 20 | < 0.1% |
| 9 | 8 | < 0.1% |
| 10 | 12 | < 0.1% |
| 11 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 4581 | 15 | |
| 4580 | 6 | < 0.1% |
| 4579 | 15 | |
| 4578 | 9 | < 0.1% |
| 4577 | 15 | |
| 4576 | 12 | |
| 4575 | 12 | |
| 4574 | 9 | < 0.1% |
| 4573 | 25 | |
| 4572 | 20 |
store_id
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 87980 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 87980 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87980 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
manager_staff_id
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 87980 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 87980 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87980 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
staff_id
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 87980 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 87980 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87980 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 47953 | |
| 2 | 40027 |
staff_fn
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| Mike | |
|---|---|
| Jon |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.5450443 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mike |
|---|---|
| 2nd row | Mike |
| 3rd row | Mike |
| 4th row | Mike |
| 5th row | Mike |
Common Values
| Value | Count | Frequency (%) |
| Mike | 47953 | |
| Jon | 40027 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mike | 47953 | |
| jon | 40027 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 47953 | |
| i | 47953 | |
| k | 47953 | |
| e | 47953 | |
| J | 40027 | |
| o | 40027 | |
| n | 40027 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 223913 | |
| Uppercase Letter | 87980 | 28.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 47953 | |
| k | 47953 | |
| e | 47953 | |
| o | 40027 | |
| n | 40027 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 47953 | |
| J | 40027 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 311893 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 47953 | |
| i | 47953 | |
| k | 47953 | |
| e | 47953 | |
| J | 40027 | |
| o | 40027 | |
| n | 40027 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 311893 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 47953 | |
| i | 47953 | |
| k | 47953 | |
| e | 47953 | |
| J | 40027 | |
| o | 40027 | |
| n | 40027 |
staff_ln
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| Hillyer | |
|---|---|
| Stephens |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.4549557 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hillyer |
|---|---|
| 2nd row | Hillyer |
| 3rd row | Hillyer |
| 4th row | Hillyer |
| 5th row | Hillyer |
Common Values
| Value | Count | Frequency (%) |
| Hillyer | 47953 | |
| Stephens | 40027 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| hillyer | 47953 | |
| stephens | 40027 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 128007 | |
| l | 95906 | |
| H | 47953 | 7.3% |
| i | 47953 | 7.3% |
| y | 47953 | 7.3% |
| r | 47953 | 7.3% |
| S | 40027 | 6.1% |
| t | 40027 | 6.1% |
| p | 40027 | 6.1% |
| h | 40027 | 6.1% |
| Other values (2) | 80054 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 567907 | |
| Uppercase Letter | 87980 | 13.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 128007 | |
| l | 95906 | |
| i | 47953 | 8.4% |
| y | 47953 | 8.4% |
| r | 47953 | 8.4% |
| t | 40027 | 7.0% |
| p | 40027 | 7.0% |
| h | 40027 | 7.0% |
| n | 40027 | 7.0% |
| s | 40027 | 7.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 47953 | |
| S | 40027 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 655887 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 128007 | |
| l | 95906 | |
| H | 47953 | 7.3% |
| i | 47953 | 7.3% |
| y | 47953 | 7.3% |
| r | 47953 | 7.3% |
| S | 40027 | 6.1% |
| t | 40027 | 6.1% |
| p | 40027 | 6.1% |
| h | 40027 | 6.1% |
| Other values (2) | 80054 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 655887 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 128007 | |
| l | 95906 | |
| H | 47953 | 7.3% |
| i | 47953 | 7.3% |
| y | 47953 | 7.3% |
| r | 47953 | 7.3% |
| S | 40027 | 6.1% |
| t | 40027 | 6.1% |
| p | 40027 | 6.1% |
| h | 40027 | 6.1% |
| Other values (2) | 80054 |
address_id
Real number (ℝ)
High correlation
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 301.90181 |
| Minimum | 5 |
|---|---|
| Maximum | 605 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 152 |
| median | 301 |
| Q3 | 451 |
| 95-th percentile | 574 |
| Maximum | 605 |
| Range | 600 |
| Interquartile range (IQR) | 299 |
Descriptive statistics
| Standard deviation | 172.88345 |
|---|---|
| Coefficient of variation (CV) | 0.57264794 |
| Kurtosis | -1.188535 |
| Mean | 301.90181 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | 0.010253583 |
| Sum | 26561321 |
| Variance | 29888.687 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 152 | 272 | 0.3% |
| 532 | 251 | 0.3% |
| 201 | 244 | 0.3% |
| 148 | 239 | 0.3% |
| 240 | 233 | 0.3% |
| 79 | 233 | 0.3% |
| 33 | 223 | 0.3% |
| 262 | 221 | 0.3% |
| 182 | 220 | 0.3% |
| 415 | 216 | 0.2% |
| Other values (589) | 85628 |
| Value | Count | Frequency (%) |
| 5 | 156 | |
| 6 | 175 | |
| 7 | 144 | |
| 8 | 121 | |
| 9 | 183 | |
| 10 | 171 | |
| 11 | 191 | |
| 12 | 152 | |
| 13 | 129 | |
| 14 | 123 |
| Value | Count | Frequency (%) |
| 605 | 102 | |
| 604 | 102 | |
| 603 | 144 | |
| 602 | 158 | |
| 601 | 141 | |
| 600 | 141 | |
| 599 | 129 | |
| 598 | 145 | |
| 597 | 120 | |
| 596 | 134 |
address
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 38 |
|---|---|
| Median length | 34 |
| Mean length | 19.461798 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 758 Junan Lane |
|---|---|
| 2nd row | 758 Junan Lane |
| 3rd row | 758 Junan Lane |
| 4th row | 758 Junan Lane |
| 5th row | 76 Kermanshah Manor |
| Value | Count | Frequency (%) |
| parkway | 11137 | 3.9% |
| manor | 9908 | 3.4% |
| avenue | 8963 | 3.1% |
| way | 8854 | 3.1% |
| lane | 8745 | 3.0% |
| street | 8622 | 3.0% |
| place | 8225 | 2.8% |
| loop | 8071 | 2.8% |
| boulevard | 7812 | 2.7% |
| drive | 7643 | 2.6% |
| Other values (957) | 201223 |
Most occurring characters
| Value | Count | Frequency (%) |
| 201223 | 11.8% | |
| a | 178952 | 10.5% |
| e | 110192 | 6.4% |
| o | 87025 | 5.1% |
| r | 83504 | 4.9% |
| n | 82148 | 4.8% |
| 1 | 67756 | 4.0% |
| i | 51591 | 3.0% |
| l | 51231 | 3.0% |
| u | 49041 | 2.9% |
| Other values (56) | 749586 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1004855 | |
| Decimal Number | 299535 | 17.5% |
| Space Separator | 201223 | 11.8% |
| Uppercase Letter | 198759 | 11.6% |
| Dash Punctuation | 3499 | 0.2% |
| Open Punctuation | 2189 | 0.1% |
| Close Punctuation | 2189 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 178952 | |
| e | 110192 | |
| o | 87025 | 8.7% |
| r | 83504 | 8.3% |
| n | 82148 | 8.2% |
| i | 51591 | 5.1% |
| l | 51231 | 5.1% |
| u | 49041 | 4.9% |
| t | 41214 | 4.1% |
| y | 29485 | 2.9% |
| Other values (16) | 240472 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 26620 | |
| L | 22014 | |
| S | 21827 | |
| B | 18491 | |
| A | 17384 | |
| M | 15293 | 7.7% |
| D | 10480 | 5.3% |
| W | 9464 | 4.8% |
| C | 9140 | 4.6% |
| T | 6523 | 3.3% |
| Other values (16) | 41523 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 67756 | |
| 6 | 29479 | |
| 4 | 29025 | |
| 9 | 28334 | |
| 7 | 26587 | 8.9% |
| 8 | 26234 | 8.8% |
| 5 | 24905 | 8.3% |
| 2 | 24523 | 8.2% |
| 3 | 23339 | 7.8% |
| 0 | 19353 | 6.5% |
Space Separator
| Value | Count | Frequency (%) |
| 201223 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3499 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2189 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2189 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1203614 | |
| Common | 508635 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 178952 | |
| e | 110192 | 9.2% |
| o | 87025 | 7.2% |
| r | 83504 | 6.9% |
| n | 82148 | 6.8% |
| i | 51591 | 4.3% |
| l | 51231 | 4.3% |
| u | 49041 | 4.1% |
| t | 41214 | 3.4% |
| y | 29485 | 2.4% |
| Other values (42) | 439231 |
Common
| Value | Count | Frequency (%) |
| 201223 | ||
| 1 | 67756 | 13.3% |
| 6 | 29479 | 5.8% |
| 4 | 29025 | 5.7% |
| 9 | 28334 | 5.6% |
| 7 | 26587 | 5.2% |
| 8 | 26234 | 5.2% |
| 5 | 24905 | 4.9% |
| 2 | 24523 | 4.8% |
| 3 | 23339 | 4.6% |
| Other values (4) | 27230 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1712249 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 201223 | 11.8% | |
| a | 178952 | 10.5% |
| e | 110192 | 6.4% |
| o | 87025 | 5.1% |
| r | 83504 | 4.9% |
| n | 82148 | 4.8% |
| 1 | 67756 | 4.0% |
| i | 51591 | 3.0% |
| l | 51231 | 3.0% |
| u | 49041 | 2.9% |
| Other values (56) | 749586 |
address2
Unsupported
Missing Rejected Unsupported
| Missing | 87980 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 87980 |
Length
Common Values (Plot)
Most occurring characters
| Value | Count | Frequency (%) |
| 87980 |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 87980 |
Most frequent character per category
Space Separator
| Value | Count | Frequency (%) |
| 87980 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 87980 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 87980 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87980 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 87980 |
postal_code
Real number (ℝ)
| Distinct | 596 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50328.658 |
| Minimum | 3 |
|---|---|
| Maximum | 99865 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 4855 |
| Q1 | 25220 |
| median | 50805 |
| Q3 | 74750 |
| 95-th percentile | 95509 |
| Maximum | 99865 |
| Range | 99862 |
| Interquartile range (IQR) | 49530 |
Descriptive statistics
| Standard deviation | 28834.472 |
|---|---|
| Coefficient of variation (CV) | 0.57292353 |
| Kurtosis | -1.1636062 |
| Mean | 50328.658 |
| Median Absolute Deviation (MAD) | 24669 |
| Skewness | -0.018899509 |
| Sum | 4.4279153 × 109 |
| Variance | 8.3142679 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 52137 | 299 | 0.3% |
| 9668 | 284 | 0.3% |
| 92150 | 272 | 0.3% |
| 22474 | 270 | 0.3% |
| 31342 | 251 | 0.3% |
| 89459 | 244 | 0.3% |
| 30861 | 239 | 0.3% |
| 72394 | 233 | 0.3% |
| 18727 | 233 | 0.3% |
| 65750 | 223 | 0.3% |
| Other values (586) | 85432 |
| Value | Count | Frequency (%) |
| 3 | 122 | |
| 400 | 138 | |
| 504 | 130 | |
| 841 | 108 | |
| 943 | 133 | |
| 966 | 118 | |
| 1027 | 132 | |
| 1079 | 122 | |
| 1195 | 146 | |
| 1545 | 190 |
| Value | Count | Frequency (%) |
| 99865 | 126 | |
| 99780 | 165 | |
| 99552 | 156 | |
| 99457 | 168 | |
| 99405 | 178 | |
| 99124 | 124 | |
| 98889 | 141 | |
| 98883 | 157 | |
| 98775 | 121 | |
| 98573 | 157 |
city_id
Real number (ℝ)
| Distinct | 597 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 301.38936 |
| Minimum | 1 |
|---|---|
| Maximum | 600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 31 |
| Q1 | 148 |
| median | 304 |
| Q3 | 452 |
| 95-th percentile | 569 |
| Maximum | 600 |
| Range | 599 |
| Interquartile range (IQR) | 304 |
Descriptive statistics
| Standard deviation | 173.50817 |
|---|---|
| Coefficient of variation (CV) | 0.57569442 |
| Kurtosis | -1.2104272 |
| Mean | 301.38936 |
| Median Absolute Deviation (MAD) | 152 |
| Skewness | -0.016232752 |
| Sum | 26516236 |
| Variance | 30105.086 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42 | 275 | 0.3% |
| 442 | 272 | 0.3% |
| 312 | 271 | 0.3% |
| 101 | 251 | 0.3% |
| 109 | 244 | 0.3% |
| 340 | 239 | 0.3% |
| 108 | 233 | 0.3% |
| 527 | 233 | 0.3% |
| 474 | 223 | 0.3% |
| 64 | 221 | 0.3% |
| Other values (587) | 85518 |
| Value | Count | Frequency (%) |
| 1 | 156 | |
| 2 | 124 | |
| 3 | 177 | |
| 4 | 160 | |
| 5 | 131 | |
| 6 | 123 | |
| 7 | 178 | |
| 8 | 136 | |
| 9 | 164 | |
| 10 | 157 |
| Value | Count | Frequency (%) |
| 600 | 131 | |
| 599 | 171 | |
| 598 | 157 | |
| 597 | 138 | |
| 596 | 153 | |
| 595 | 81 | |
| 594 | 123 | |
| 593 | 144 | |
| 592 | 139 | |
| 591 | 137 |
city
Text
| Distinct | 597 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 21 |
| Mean length | 8.3905433 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | guas Lindas de Gois |
|---|---|
| 2nd row | guas Lindas de Gois |
| 3rd row | guas Lindas de Gois |
| 4th row | guas Lindas de Gois |
| 5th row | Qomsheh |
| Value | Count | Frequency (%) |
| de | 1920 | 1.8% |
| san | 946 | 0.9% |
| la | 727 | 0.7% |
| del | 581 | 0.5% |
| santa | 578 | 0.5% |
| el | 433 | 0.4% |
| hill | 411 | 0.4% |
| santiago | 395 | 0.4% |
| plata | 353 | 0.3% |
| felipe | 344 | 0.3% |
| Other values (673) | 100656 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 109594 | 14.8% |
| n | 52055 | 7.1% |
| o | 47619 | 6.5% |
| i | 46517 | 6.3% |
| e | 42688 | 5.8% |
| r | 38393 | 5.2% |
| u | 34216 | 4.6% |
| l | 30362 | 4.1% |
| s | 24830 | 3.4% |
| t | 24653 | 3.3% |
| Other values (47) | 287273 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 605191 | |
| Uppercase Letter | 106585 | 14.4% |
| Space Separator | 19364 | 2.6% |
| Dash Punctuation | 3852 | 0.5% |
| Close Punctuation | 1522 | 0.2% |
| Open Punctuation | 1522 | 0.2% |
| Other Punctuation | 164 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 109594 | |
| n | 52055 | 8.6% |
| o | 47619 | 7.9% |
| i | 46517 | 7.7% |
| e | 42688 | 7.1% |
| r | 38393 | 6.3% |
| u | 34216 | 5.7% |
| l | 30362 | 5.0% |
| s | 24830 | 4.1% |
| t | 24653 | 4.1% |
| Other values (16) | 154264 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 13282 | 12.5% |
| B | 9638 | 9.0% |
| A | 7252 | 6.8% |
| C | 7249 | 6.8% |
| P | 6320 | 5.9% |
| T | 6224 | 5.8% |
| K | 5920 | 5.6% |
| M | 5791 | 5.4% |
| L | 5210 | 4.9% |
| H | 4334 | 4.1% |
| Other values (16) | 35365 |
Space Separator
| Value | Count | Frequency (%) |
| 19364 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3852 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1522 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1522 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 164 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 711776 | |
| Common | 26424 | 3.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 109594 | |
| n | 52055 | 7.3% |
| o | 47619 | 6.7% |
| i | 46517 | 6.5% |
| e | 42688 | 6.0% |
| r | 38393 | 5.4% |
| u | 34216 | 4.8% |
| l | 30362 | 4.3% |
| s | 24830 | 3.5% |
| t | 24653 | 3.5% |
| Other values (42) | 260849 |
Common
| Value | Count | Frequency (%) |
| 19364 | ||
| - | 3852 | 14.6% |
| ) | 1522 | 5.8% |
| ( | 1522 | 5.8% |
| / | 164 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 738200 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 109594 | 14.8% |
| n | 52055 | 7.1% |
| o | 47619 | 6.5% |
| i | 46517 | 6.3% |
| e | 42688 | 5.8% |
| r | 38393 | 5.2% |
| u | 34216 | 4.6% |
| l | 30362 | 4.1% |
| s | 24830 | 3.4% |
| t | 24653 | 3.3% |
| Other values (47) | 287273 |
country_id
Real number (ℝ)
| Distinct | 108 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.862946 |
| Minimum | 1 |
|---|---|
| Maximum | 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 29 |
| median | 50 |
| Q3 | 80 |
| 95-th percentile | 103 |
| Maximum | 109 |
| Range | 108 |
| Interquartile range (IQR) | 51 |
Descriptive statistics
| Standard deviation | 30.063209 |
|---|---|
| Coefficient of variation (CV) | 0.52869595 |
| Kurtosis | -1.1599807 |
| Mean | 56.862946 |
| Median Absolute Deviation (MAD) | 27 |
| Skewness | 0.056106303 |
| Sum | 5002802 |
| Variance | 903.79656 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44 | 8637 | 9.8% |
| 23 | 7724 | 8.8% |
| 103 | 5428 | 6.2% |
| 50 | 4565 | 5.2% |
| 60 | 4493 | 5.1% |
| 15 | 4042 | 4.6% |
| 80 | 3895 | 4.4% |
| 75 | 3160 | 3.6% |
| 97 | 2094 | 2.4% |
| 45 | 2014 | 2.3% |
| Other values (98) | 41928 |
| Value | Count | Frequency (%) |
| 1 | 109 | 0.1% |
| 2 | 457 | 0.5% |
| 3 | 111 | 0.1% |
| 4 | 301 | 0.3% |
| 5 | 195 | 0.2% |
| 6 | 1884 | |
| 7 | 150 | 0.2% |
| 9 | 403 | 0.5% |
| 10 | 302 | 0.3% |
| 11 | 134 | 0.2% |
| Value | Count | Frequency (%) |
| 109 | 174 | 0.2% |
| 108 | 328 | 0.4% |
| 107 | 628 | 0.7% |
| 106 | 190 | 0.2% |
| 105 | 908 | 1.0% |
| 104 | 963 | 1.1% |
| 103 | 5428 | |
| 102 | 1210 | 1.4% |
| 101 | 476 | 0.5% |
| 100 | 823 | 0.9% |
country
Text
| Distinct | 108 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
Length
| Max length | 37 |
|---|---|
| Median length | 29 |
| Mean length | 8.1365765 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Brazil |
|---|---|
| 2nd row | Brazil |
| 3rd row | Brazil |
| 4th row | Brazil |
| 5th row | Iran |
| Value | Count | Frequency (%) |
| india | 8637 | 8.0% |
| china | 7724 | 7.2% |
| united | 7114 | 6.6% |
| states | 5428 | 5.0% |
| japan | 4565 | 4.2% |
| mexico | 4493 | 4.2% |
| brazil | 4042 | 3.8% |
| russian | 3895 | 3.6% |
| federation | 3895 | 3.6% |
| philippines | 3160 | 2.9% |
| Other values (122) | 54818 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 95628 | 13.4% |
| i | 80527 | 11.2% |
| n | 72671 | 10.2% |
| e | 58230 | 8.1% |
| t | 35504 | 5.0% |
| r | 31038 | 4.3% |
| d | 30203 | 4.2% |
| o | 26432 | 3.7% |
| s | 25093 | 3.5% |
| l | 20000 | 2.8% |
| Other values (44) | 240530 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 587642 | |
| Uppercase Letter | 107199 | 15.0% |
| Space Separator | 19791 | 2.8% |
| Other Punctuation | 818 | 0.1% |
| Open Punctuation | 203 | < 0.1% |
| Close Punctuation | 203 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 95628 | |
| i | 80527 | |
| n | 72671 | |
| e | 58230 | |
| t | 35504 | 6.0% |
| r | 31038 | 5.3% |
| d | 30203 | 5.1% |
| o | 26432 | 4.5% |
| s | 25093 | 4.3% |
| l | 20000 | 3.4% |
| Other values (16) | 112316 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 13962 | |
| S | 11266 | |
| C | 11076 | |
| U | 8127 | 7.6% |
| A | 6693 | 6.2% |
| P | 6557 | 6.1% |
| M | 6538 | 6.1% |
| B | 5804 | 5.4% |
| R | 5699 | 5.3% |
| T | 5497 | 5.1% |
| Other values (13) | 25980 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 438 | |
| . | 380 |
Space Separator
| Value | Count | Frequency (%) |
| 19791 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 203 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 203 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 694841 | |
| Common | 21015 | 2.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 95628 | |
| i | 80527 | 11.6% |
| n | 72671 | 10.5% |
| e | 58230 | 8.4% |
| t | 35504 | 5.1% |
| r | 31038 | 4.5% |
| d | 30203 | 4.3% |
| o | 26432 | 3.8% |
| s | 25093 | 3.6% |
| l | 20000 | 2.9% |
| Other values (39) | 219515 |
Common
| Value | Count | Frequency (%) |
| 19791 | ||
| , | 438 | 2.1% |
| . | 380 | 1.8% |
| ( | 203 | 1.0% |
| ) | 203 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 715856 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 95628 | 13.4% |
| i | 80527 | 11.2% |
| n | 72671 | 10.2% |
| e | 58230 | 8.1% |
| t | 35504 | 5.0% |
| r | 31038 | 4.3% |
| d | 30203 | 4.2% |
| o | 26432 | 3.7% |
| s | 25093 | 3.5% |
| l | 20000 | 2.8% |
| Other values (44) | 240530 |
category_id
Real number (ℝ)
High correlation
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.3390657 |
| Minimum | 1 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 8 |
| Q3 | 13 |
| 95-th percentile | 16 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 4.7002421 |
|---|---|
| Coefficient of variation (CV) | 0.56364133 |
| Kurtosis | -1.2488883 |
| Mean | 8.3390657 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.039042849 |
| Sum | 733671 |
| Variance | 22.092276 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15 | 6936 | 7.9% |
| 2 | 6600 | 7.5% |
| 1 | 6307 | 7.2% |
| 6 | 6188 | 7.0% |
| 7 | 5929 | 6.7% |
| 14 | 5743 | 6.5% |
| 8 | 5615 | 6.4% |
| 9 | 5559 | 6.3% |
| 3 | 5510 | 6.3% |
| 13 | 5192 | 5.9% |
| Other values (6) | 28401 |
| Value | Count | Frequency (%) |
| 1 | 6307 | |
| 2 | 6600 | |
| 3 | 5510 | |
| 4 | 5088 | |
| 5 | 4662 | |
| 6 | 6188 | |
| 7 | 5929 | |
| 8 | 5615 | |
| 9 | 5559 | |
| 10 | 4552 |
| Value | Count | Frequency (%) |
| 16 | 4668 | |
| 15 | 6936 | |
| 14 | 5743 | |
| 13 | 5192 | |
| 12 | 4503 | |
| 11 | 4928 | |
| 10 | 4552 | |
| 9 | 5559 | |
| 8 | 5615 | |
| 7 | 5929 |
category
Categorical
High correlation
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| Sports | |
|---|---|
| Animation | |
| Action | |
| Documentary | |
| Drama | |
| Other values (11) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 6.5334735 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Family |
|---|---|
| 2nd row | Family |
| 3rd row | Family |
| 4th row | Family |
| 5th row | Music |
Common Values
| Value | Count | Frequency (%) |
| Sports | 6936 | 7.9% |
| Animation | 6600 | 7.5% |
| Action | 6307 | 7.2% |
| Documentary | 6188 | 7.0% |
| Drama | 5929 | 6.7% |
| Sci-Fi | 5743 | 6.5% |
| Family | 5615 | 6.4% |
| Foreign | 5559 | 6.3% |
| Children | 5510 | 6.3% |
| New | 5192 | 5.9% |
| Other values (6) | 28401 |
Length
| Value | Count | Frequency (%) |
| sports | 6936 | 7.9% |
| animation | 6600 | 7.5% |
| action | 6307 | 7.2% |
| documentary | 6188 | 7.0% |
| drama | 5929 | 6.7% |
| sci-fi | 5743 | 6.5% |
| family | 5615 | 6.4% |
| foreign | 5559 | 6.3% |
| children | 5510 | 6.3% |
| new | 5192 | 5.9% |
| Other values (6) | 28401 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 57268 | 10.0% |
| r | 49574 | 8.6% |
| o | 46108 | 8.0% |
| a | 44569 | 7.8% |
| n | 36764 | 6.4% |
| e | 36331 | 6.3% |
| m | 33546 | 5.8% |
| s | 31255 | 5.4% |
| c | 27829 | 4.8% |
| t | 26031 | 4.5% |
| Other values (20) | 185540 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 475349 | |
| Uppercase Letter | 93723 | 16.3% |
| Dash Punctuation | 5743 | 1.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 57268 | |
| r | 49574 | |
| o | 46108 | |
| a | 44569 | |
| n | 36764 | |
| e | 36331 | |
| m | 33546 | 7.1% |
| s | 31255 | 6.6% |
| c | 27829 | 5.9% |
| t | 26031 | 5.5% |
| Other values (9) | 86074 |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 16917 | |
| C | 15260 | |
| A | 12907 | |
| S | 12679 | |
| D | 12117 | |
| N | 5192 | 5.5% |
| H | 4928 | 5.3% |
| T | 4668 | 5.0% |
| G | 4552 | 4.9% |
| M | 4503 | 4.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5743 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 569072 | |
| Common | 5743 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 57268 | 10.1% |
| r | 49574 | 8.7% |
| o | 46108 | 8.1% |
| a | 44569 | 7.8% |
| n | 36764 | 6.5% |
| e | 36331 | 6.4% |
| m | 33546 | 5.9% |
| s | 31255 | 5.5% |
| c | 27829 | 4.9% |
| t | 26031 | 4.6% |
| Other values (19) | 179797 |
Common
| Value | Count | Frequency (%) |
| - | 5743 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 574815 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 57268 | 10.0% |
| r | 49574 | 8.6% |
| o | 46108 | 8.0% |
| a | 44569 | 7.8% |
| n | 36764 | 6.4% |
| e | 36331 | 6.3% |
| m | 33546 | 5.8% |
| s | 31255 | 5.4% |
| c | 27829 | 4.8% |
| t | 26031 | 4.5% |
| Other values (20) | 185540 |
language
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.5 KiB |
| English |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | English |
|---|---|
| 2nd row | English |
| 3rd row | English |
| 4th row | English |
| 5th row | English |
Common Values
| Value | Count | Frequency (%) |
| English | 87980 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| english | 87980 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 87980 | |
| n | 87980 | |
| g | 87980 | |
| l | 87980 | |
| i | 87980 | |
| s | 87980 | |
| h | 87980 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 527880 | |
| Uppercase Letter | 87980 | 14.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 87980 | |
| g | 87980 | |
| l | 87980 | |
| i | 87980 | |
| s | 87980 | |
| h | 87980 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 87980 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 615860 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 87980 | |
| n | 87980 | |
| g | 87980 | |
| l | 87980 | |
| i | 87980 | |
| s | 87980 | |
| h | 87980 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 615860 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 87980 | |
| n | 87980 | |
| g | 87980 | |
| l | 87980 | |
| i | 87980 | |
| s | 87980 | |
| h | 87980 |
film_category_id
Real number (ℝ)
High correlation
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 502.11853 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 48 |
| Q1 | 255 |
| median | 496 |
| Q3 | 752 |
| 95-th percentile | 952 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 497 |
Descriptive statistics
| Standard deviation | 288.32439 |
|---|---|
| Coefficient of variation (CV) | 0.57421581 |
| Kurtosis | -1.1870348 |
| Mean | 502.11853 |
| Median Absolute Deviation (MAD) | 247 |
| Skewness | -0.010455299 |
| Sum | 44176388 |
| Variance | 83130.956 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 489 | 288 | 0.3% |
| 892 | 276 | 0.3% |
| 880 | 275 | 0.3% |
| 249 | 273 | 0.3% |
| 649 | 264 | 0.3% |
| 301 | 261 | 0.3% |
| 764 | 252 | 0.3% |
| 418 | 248 | 0.3% |
| 369 | 248 | 0.3% |
| 414 | 240 | 0.3% |
| Other values (945) | 85355 |
| Value | Count | Frequency (%) |
| 1 | 230 | |
| 2 | 28 | < 0.1% |
| 3 | 60 | 0.1% |
| 4 | 115 | |
| 5 | 60 | 0.1% |
| 6 | 147 | |
| 7 | 75 | 0.1% |
| 8 | 72 | 0.1% |
| 9 | 108 | |
| 10 | 184 |
| Value | Count | Frequency (%) |
| 1000 | 93 | |
| 999 | 85 | |
| 998 | 54 | 0.1% |
| 997 | 30 | < 0.1% |
| 996 | 35 | < 0.1% |
| 995 | 23 | < 0.1% |
| 994 | 78 | |
| 993 | 180 | |
| 992 | 56 | 0.1% |
| 991 | 64 | 0.1% |
film_actor_id
Real number (ℝ)
High correlation
| Distinct | 200 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.9536 |
| Minimum | 1 |
|---|---|
| Maximum | 200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 52 |
| median | 102 |
| Q3 | 149 |
| 95-th percentile | 191 |
| Maximum | 200 |
| Range | 199 |
| Interquartile range (IQR) | 97 |
Descriptive statistics
| Standard deviation | 56.900302 |
|---|---|
| Coefficient of variation (CV) | 0.56362824 |
| Kurtosis | -1.1747542 |
| Mean | 100.9536 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | 0.0020452118 |
| Sum | 8881898 |
| Variance | 3237.6443 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 107 | 753 | 0.9% |
| 181 | 678 | 0.8% |
| 198 | 674 | 0.8% |
| 144 | 654 | 0.7% |
| 102 | 640 | 0.7% |
| 60 | 612 | 0.7% |
| 150 | 611 | 0.7% |
| 37 | 605 | 0.7% |
| 23 | 604 | 0.7% |
| 90 | 599 | 0.7% |
| Other values (190) | 81550 |
| Value | Count | Frequency (%) |
| 1 | 305 | |
| 2 | 387 | |
| 3 | 311 | |
| 4 | 274 | |
| 5 | 496 | |
| 6 | 279 | |
| 7 | 479 | |
| 8 | 317 | |
| 9 | 381 | |
| 10 | 362 |
| Value | Count | Frequency (%) |
| 200 | 346 | |
| 199 | 255 | 0.3% |
| 198 | 674 | |
| 197 | 553 | |
| 196 | 450 | |
| 195 | 450 | |
| 194 | 380 | |
| 193 | 444 | |
| 192 | 458 | |
| 191 | 523 |
Interactions
Correlations
| active | actor_id | address_id | amount | category | category_id | city_id | country_id | customer_id | film_actor_id | film_category_id | film_id | inventory_id | length | manager_staff_id | payment_id | postal_code | rating | rental_duration | rental_id | rental_rate | replacement_cost | staff_fn | staff_id | staff_ln | store_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| active | 1.000 | 0.000 | 0.085 | 0.027 | 0.032 | 0.021 | 0.109 | 0.094 | 0.092 | 0.000 | 0.023 | 0.023 | 0.021 | 0.029 | 0.003 | 0.092 | 0.138 | 0.014 | 0.012 | 0.021 | 0.007 | 0.018 | 0.003 | 0.003 | 0.003 | 0.003 |
| actor_id | 0.000 | 1.000 | 0.001 | -0.007 | 0.056 | 0.011 | 0.002 | 0.001 | 0.001 | 1.000 | 0.015 | 0.015 | 0.015 | 0.015 | 0.000 | 0.001 | 0.004 | 0.043 | 0.041 | -0.003 | 0.042 | -0.001 | 0.000 | 0.000 | 0.000 | 0.000 |
| address_id | 0.085 | 0.001 | 1.000 | 0.014 | 0.032 | 0.024 | 0.042 | -0.042 | 1.000 | 0.001 | -0.003 | -0.003 | -0.003 | -0.013 | 0.075 | 1.000 | -0.043 | 0.019 | 0.028 | -0.004 | 0.027 | -0.022 | 0.075 | 0.075 | 0.075 | 0.075 |
| amount | 0.027 | -0.007 | 0.014 | 1.000 | 0.065 | 0.087 | 0.001 | 0.013 | 0.014 | -0.007 | 0.027 | 0.027 | 0.027 | 0.003 | 0.016 | 0.014 | -0.012 | 0.034 | 0.171 | 0.002 | 0.706 | -0.030 | 0.016 | 0.016 | 0.016 | 0.016 |
| category | 0.032 | 0.056 | 0.032 | 0.065 | 1.000 | 1.000 | 0.033 | 0.029 | 0.032 | 0.056 | 0.139 | 0.139 | 0.138 | 0.149 | 0.030 | 0.031 | 0.029 | 0.156 | 0.161 | 0.024 | 0.145 | 0.141 | 0.030 | 0.030 | 0.030 | 0.030 |
| category_id | 0.021 | 0.011 | 0.024 | 0.087 | 1.000 | 1.000 | 0.001 | -0.003 | 0.024 | 0.011 | -0.027 | -0.027 | -0.027 | 0.093 | 0.019 | 0.024 | -0.005 | 0.113 | 0.104 | 0.008 | 0.116 | -0.033 | 0.019 | 0.019 | 0.019 | 0.019 |
| city_id | 0.109 | 0.002 | 0.042 | 0.001 | 0.033 | 0.001 | 1.000 | -0.059 | 0.042 | 0.002 | 0.009 | 0.009 | 0.009 | -0.002 | 0.105 | 0.042 | -0.071 | 0.020 | 0.021 | -0.005 | 0.026 | -0.001 | 0.105 | 0.105 | 0.105 | 0.105 |
| country_id | 0.094 | 0.001 | -0.042 | 0.013 | 0.029 | -0.003 | -0.059 | 1.000 | -0.042 | 0.001 | 0.017 | 0.017 | 0.017 | 0.012 | 0.102 | -0.042 | 0.001 | 0.023 | 0.021 | -0.005 | 0.020 | 0.004 | 0.102 | 0.102 | 0.102 | 0.102 |
| customer_id | 0.092 | 0.001 | 1.000 | 0.014 | 0.032 | 0.024 | 0.042 | -0.042 | 1.000 | 0.001 | -0.003 | -0.003 | -0.003 | -0.013 | 0.074 | 1.000 | -0.043 | 0.018 | 0.028 | -0.004 | 0.027 | -0.022 | 0.074 | 0.074 | 0.074 | 0.074 |
| film_actor_id | 0.000 | 1.000 | 0.001 | -0.007 | 0.056 | 0.011 | 0.002 | 0.001 | 0.001 | 1.000 | 0.015 | 0.015 | 0.015 | 0.015 | 0.000 | 0.001 | 0.004 | 0.043 | 0.041 | -0.003 | 0.042 | -0.001 | 0.000 | 0.000 | 0.000 | 0.000 |
| film_category_id | 0.023 | 0.015 | -0.003 | 0.027 | 0.139 | -0.027 | 0.009 | 0.017 | -0.003 | 0.015 | 1.000 | 1.000 | 1.000 | 0.054 | 0.034 | -0.003 | -0.009 | 0.120 | 0.113 | -0.002 | 0.112 | -0.040 | 0.034 | 0.034 | 0.034 | 0.034 |
| film_id | 0.023 | 0.015 | -0.003 | 0.027 | 0.139 | -0.027 | 0.009 | 0.017 | -0.003 | 0.015 | 1.000 | 1.000 | 1.000 | 0.054 | 0.034 | -0.003 | -0.009 | 0.120 | 0.113 | -0.002 | 0.112 | -0.040 | 0.034 | 0.034 | 0.034 | 0.034 |
| inventory_id | 0.021 | 0.015 | -0.003 | 0.027 | 0.138 | -0.027 | 0.009 | 0.017 | -0.003 | 0.015 | 1.000 | 1.000 | 1.000 | 0.054 | 0.032 | -0.003 | -0.009 | 0.118 | 0.112 | -0.002 | 0.116 | -0.040 | 0.032 | 0.032 | 0.032 | 0.032 |
| length | 0.029 | 0.015 | -0.013 | 0.003 | 0.149 | 0.093 | -0.002 | 0.012 | -0.013 | 0.015 | 0.054 | 0.054 | 0.054 | 1.000 | 0.016 | -0.013 | -0.004 | 0.101 | 0.087 | 0.001 | 0.105 | 0.014 | 0.016 | 0.016 | 0.016 | 0.016 |
| manager_staff_id | 0.003 | 0.000 | 0.075 | 0.016 | 0.030 | 0.019 | 0.105 | 0.102 | 0.074 | 0.000 | 0.034 | 0.034 | 0.032 | 0.016 | 1.000 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| payment_id | 0.092 | 0.001 | 1.000 | 0.014 | 0.031 | 0.024 | 0.042 | -0.042 | 1.000 | 0.001 | -0.003 | -0.003 | -0.003 | -0.013 | 0.072 | 1.000 | -0.043 | 0.017 | 0.028 | -0.002 | 0.025 | -0.022 | 0.072 | 0.072 | 0.072 | 0.072 |
| postal_code | 0.138 | 0.004 | -0.043 | -0.012 | 0.029 | -0.005 | -0.071 | 0.001 | -0.043 | 0.004 | -0.009 | -0.009 | -0.009 | -0.004 | 0.090 | -0.043 | 1.000 | 0.017 | 0.015 | 0.006 | 0.026 | -0.001 | 0.090 | 0.090 | 0.090 | 0.090 |
| rating | 0.014 | 0.043 | 0.019 | 0.034 | 0.156 | 0.113 | 0.020 | 0.023 | 0.018 | 0.043 | 0.120 | 0.120 | 0.118 | 0.101 | 0.015 | 0.017 | 0.017 | 1.000 | 0.096 | 0.020 | 0.038 | 0.112 | 0.015 | 0.015 | 0.015 | 0.015 |
| rental_duration | 0.012 | 0.041 | 0.028 | 0.171 | 0.161 | 0.104 | 0.021 | 0.021 | 0.028 | 0.041 | 0.113 | 0.113 | 0.112 | 0.087 | 0.007 | 0.028 | 0.015 | 0.096 | 1.000 | 0.021 | 0.072 | 0.083 | 0.007 | 0.007 | 0.007 | 0.007 |
| rental_id | 0.021 | -0.003 | -0.004 | 0.002 | 0.024 | 0.008 | -0.005 | -0.005 | -0.004 | -0.003 | -0.002 | -0.002 | -0.002 | 0.001 | 0.028 | -0.002 | 0.006 | 0.020 | 0.021 | 1.000 | 0.024 | 0.004 | 0.028 | 0.028 | 0.028 | 0.028 |
| rental_rate | 0.007 | 0.042 | 0.027 | 0.706 | 0.145 | 0.116 | 0.026 | 0.020 | 0.027 | 0.042 | 0.112 | 0.112 | 0.116 | 0.105 | 0.000 | 0.025 | 0.026 | 0.038 | 0.072 | 0.024 | 1.000 | 0.109 | 0.000 | 0.000 | 0.000 | 0.000 |
| replacement_cost | 0.018 | -0.001 | -0.022 | -0.030 | 0.141 | -0.033 | -0.001 | 0.004 | -0.022 | -0.001 | -0.040 | -0.040 | -0.040 | 0.014 | 0.027 | -0.022 | -0.001 | 0.112 | 0.083 | 0.004 | 0.109 | 1.000 | 0.027 | 0.027 | 0.027 | 0.027 |
| staff_fn | 0.003 | 0.000 | 0.075 | 0.016 | 0.030 | 0.019 | 0.105 | 0.102 | 0.074 | 0.000 | 0.034 | 0.034 | 0.032 | 0.016 | 1.000 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| staff_id | 0.003 | 0.000 | 0.075 | 0.016 | 0.030 | 0.019 | 0.105 | 0.102 | 0.074 | 0.000 | 0.034 | 0.034 | 0.032 | 0.016 | 1.000 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| staff_ln | 0.003 | 0.000 | 0.075 | 0.016 | 0.030 | 0.019 | 0.105 | 0.102 | 0.074 | 0.000 | 0.034 | 0.034 | 0.032 | 0.016 | 1.000 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| store_id | 0.003 | 0.000 | 0.075 | 0.016 | 0.030 | 0.019 | 0.105 | 0.102 | 0.074 | 0.000 | 0.034 | 0.034 | 0.032 | 0.016 | 1.000 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
Missing values
Sample
| film_id | title | description | release_year | language_id | rental_duration | rental_rate | length | replacement_cost | rating | actor_id | actor_fn | actor_ln | customer_id | cust_fn | cust_ln | active | rental_id | rental_date | return_date | payment_id | amount | payment_date | inventory_id | store_id | manager_staff_id | staff_id | staff_fn | staff_ln | address_id | address | address2 | district | postal_code | city_id | city | country_id | country | category_id | category | language | film_category_id | film_actor_id | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 80 | BLANKET BEVERLY | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria | 2006 | 1 | 7 | 2.99 | 148 | 21.99 | G | 16 | FRED | COSTNER | 130 | CHARLOTTE | HUNTER | CHARLOTTE.HUNTER@sakilacustomer.org | 1 | 1 | 2005-05-24 22:53:30.000 | 2005-05-26 22:04:30.000 | 3504 | 2.99 | 2005-05-24 22:53:30.000 | 367 | 1 | 1 | 1 | Mike | Hillyer | 134 | 758 Junan Lane | NaN | 82639 | 190 | guas Lindas de Gois | 15 | Brazil | 8 | Family | English | 80 | 16 | |
| 1 | 80 | BLANKET BEVERLY | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria | 2006 | 1 | 7 | 2.99 | 148 | 21.99 | G | 173 | ALAN | DREYFUSS | 130 | CHARLOTTE | HUNTER | CHARLOTTE.HUNTER@sakilacustomer.org | 1 | 1 | 2005-05-24 22:53:30.000 | 2005-05-26 22:04:30.000 | 3504 | 2.99 | 2005-05-24 22:53:30.000 | 367 | 1 | 1 | 1 | Mike | Hillyer | 134 | 758 Junan Lane | NaN | 82639 | 190 | guas Lindas de Gois | 15 | Brazil | 8 | Family | English | 80 | 173 | |
| 2 | 80 | BLANKET BEVERLY | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria | 2006 | 1 | 7 | 2.99 | 148 | 21.99 | G | 193 | BURT | TEMPLE | 130 | CHARLOTTE | HUNTER | CHARLOTTE.HUNTER@sakilacustomer.org | 1 | 1 | 2005-05-24 22:53:30.000 | 2005-05-26 22:04:30.000 | 3504 | 2.99 | 2005-05-24 22:53:30.000 | 367 | 1 | 1 | 1 | Mike | Hillyer | 134 | 758 Junan Lane | NaN | 82639 | 190 | guas Lindas de Gois | 15 | Brazil | 8 | Family | English | 80 | 193 | |
| 3 | 80 | BLANKET BEVERLY | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria | 2006 | 1 | 7 | 2.99 | 148 | 21.99 | G | 200 | THORA | TEMPLE | 130 | CHARLOTTE | HUNTER | CHARLOTTE.HUNTER@sakilacustomer.org | 1 | 1 | 2005-05-24 22:53:30.000 | 2005-05-26 22:04:30.000 | 3504 | 2.99 | 2005-05-24 22:53:30.000 | 367 | 1 | 1 | 1 | Mike | Hillyer | 134 | 758 Junan Lane | NaN | 82639 | 190 | guas Lindas de Gois | 15 | Brazil | 8 | Family | English | 80 | 200 | |
| 4 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 2006 | 1 | 7 | 2.99 | 126 | 16.99 | R | 42 | TOM | MIRANDA | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | NaN | 23343 | 423 | Qomsheh | 46 | Iran | 12 | Music | English | 333 | 42 | |
| 5 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 2006 | 1 | 7 | 2.99 | 126 | 16.99 | R | 103 | MATTHEW | LEIGH | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | NaN | 23343 | 423 | Qomsheh | 46 | Iran | 12 | Music | English | 333 | 103 | |
| 6 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 2006 | 1 | 7 | 2.99 | 126 | 16.99 | R | 105 | SIDNEY | CROWE | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | NaN | 23343 | 423 | Qomsheh | 46 | Iran | 12 | Music | English | 333 | 105 | |
| 7 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 2006 | 1 | 7 | 2.99 | 126 | 16.99 | R | 127 | KEVIN | GARLAND | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | NaN | 23343 | 423 | Qomsheh | 46 | Iran | 12 | Music | English | 333 | 127 | |
| 8 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 2006 | 1 | 7 | 2.99 | 126 | 16.99 | R | 147 | FAY | WINSLET | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | NaN | 23343 | 423 | Qomsheh | 46 | Iran | 12 | Music | English | 333 | 147 | |
| 9 | 373 | GRADUATE LORD | A Lacklusture Epistle of a Girl And a A Shark who must Meet a Mad Scientist in Ancient China | 2006 | 1 | 7 | 2.99 | 156 | 14.99 | G | 139 | EWAN | GOODING | 408 | MANUEL | MURRELL | MANUEL.MURRELL@sakilacustomer.org | 1 | 3 | 2005-05-24 23:03:39.000 | 2005-06-01 22:12:39.000 | 11032 | 3.99 | 2005-05-24 23:03:39.000 | 1711 | 1 | 1 | 1 | Mike | Hillyer | 413 | 692 Amroha Drive | NaN | 35575 | 230 | Jaffna | 88 | Sri Lanka | 3 | Children | English | 373 | 139 |
| film_id | title | description | release_year | language_id | rental_duration | rental_rate | length | replacement_cost | rating | actor_id | actor_fn | actor_ln | customer_id | cust_fn | cust_ln | active | rental_id | rental_date | return_date | payment_id | amount | payment_date | inventory_id | store_id | manager_staff_id | staff_id | staff_fn | staff_ln | address_id | address | address2 | district | postal_code | city_id | city | country_id | country | category_id | category | language | film_category_id | film_actor_id | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87970 | 452 | ILLUSION AMELIE | A Emotional Epistle of a Boat And a Mad Scientist who must Outrace a Robot in An Abandoned Mine Shaft | 2006 | 1 | 4 | 0.99 | 122 | 15.99 | R | 133 | RICHARD | PENN | 114 | GRACE | ELLIS | GRACE.ELLIS@sakilacustomer.org | 1 | 16047 | 2005-08-23 22:42:48.000 | 2005-08-25 02:48:48.000 | 3089 | 0.99 | 2005-08-23 22:42:48.000 | 2088 | 2 | 2 | 2 | Jon | Stephens | 118 | 442 Rae Bareli Place | NaN | 24321 | 148 | Duisburg | 38 | Germany | 9 | Foreign | English | 452 | 133 | |
| 87971 | 452 | ILLUSION AMELIE | A Emotional Epistle of a Boat And a Mad Scientist who must Outrace a Robot in An Abandoned Mine Shaft | 2006 | 1 | 4 | 0.99 | 122 | 15.99 | R | 184 | HUMPHREY | GARLAND | 114 | GRACE | ELLIS | GRACE.ELLIS@sakilacustomer.org | 1 | 16047 | 2005-08-23 22:42:48.000 | 2005-08-25 02:48:48.000 | 3089 | 0.99 | 2005-08-23 22:42:48.000 | 2088 | 2 | 2 | 2 | Jon | Stephens | 118 | 442 Rae Bareli Place | NaN | 24321 | 148 | Duisburg | 38 | Germany | 9 | Foreign | English | 452 | 184 | |
| 87972 | 439 | HUNCHBACK IMPOSSIBLE | A Touching Yarn of a Frisbee And a Dentist who must Fight a Composer in Ancient Japan | 2006 | 1 | 4 | 4.99 | 151 | 28.99 | PG-13 | 106 | GROUCHO | DUNST | 103 | GLADYS | HAMILTON | GLADYS.HAMILTON@sakilacustomer.org | 1 | 16048 | 2005-08-23 22:43:07.000 | 2005-08-31 21:33:07.000 | 2799 | 8.99 | 2005-08-23 22:43:07.000 | 2019 | 1 | 1 | 1 | Mike | Hillyer | 107 | 1177 Jelets Way | NaN | 3305 | 220 | Ilorin | 69 | Nigeria | 7 | Drama | English | 439 | 106 | |
| 87973 | 439 | HUNCHBACK IMPOSSIBLE | A Touching Yarn of a Frisbee And a Dentist who must Fight a Composer in Ancient Japan | 2006 | 1 | 4 | 4.99 | 151 | 28.99 | PG-13 | 175 | WILLIAM | HACKMAN | 103 | GLADYS | HAMILTON | GLADYS.HAMILTON@sakilacustomer.org | 1 | 16048 | 2005-08-23 22:43:07.000 | 2005-08-31 21:33:07.000 | 2799 | 8.99 | 2005-08-23 22:43:07.000 | 2019 | 1 | 1 | 1 | Mike | Hillyer | 107 | 1177 Jelets Way | NaN | 3305 | 220 | Ilorin | 69 | Nigeria | 7 | Drama | English | 439 | 175 | |
| 87974 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 2006 | 1 | 4 | 0.99 | 105 | 25.99 | G | 24 | CAMERON | STREEP | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | NaN | 8816 | 278 | Korolev | 80 | Russian Federation | 7 | Drama | English | 585 | 24 | |
| 87975 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 2006 | 1 | 4 | 0.99 | 105 | 25.99 | G | 31 | SISSY | SOBIESKI | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | NaN | 8816 | 278 | Korolev | 80 | Russian Federation | 7 | Drama | English | 585 | 31 | |
| 87976 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 2006 | 1 | 4 | 0.99 | 105 | 25.99 | G | 32 | TIM | HACKMAN | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | NaN | 8816 | 278 | Korolev | 80 | Russian Federation | 7 | Drama | English | 585 | 32 | |
| 87977 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 2006 | 1 | 4 | 0.99 | 105 | 25.99 | G | 61 | CHRISTIAN | NEESON | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | NaN | 8816 | 278 | Korolev | 80 | Russian Federation | 7 | Drama | English | 585 | 61 | |
| 87978 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 2006 | 1 | 4 | 0.99 | 105 | 25.99 | G | 103 | MATTHEW | LEIGH | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | NaN | 8816 | 278 | Korolev | 80 | Russian Federation | 7 | Drama | English | 585 | 103 | |
| 87979 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 2006 | 1 | 4 | 0.99 | 105 | 25.99 | G | 106 | GROUCHO | DUNST | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | NaN | 8816 | 278 | Korolev | 80 | Russian Federation | 7 | Drama | English | 585 | 106 |